﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DAL;
using System.Data;

namespace BLL
{
    public class BLL
    {
        DataAccess ac = new DataAccess();
        //hien thi bang
        public DataTable ShowData(String sql)
        {
            //string sql = "select * from tblLichDay";
            return ac.GetTable(sql);
        }
        //them
        public void Insert(string sql)
        {
            //string sql = "insert into tblSinhVien values('"+masv+"','"+tensv+"')";
            ac.ExcuteNonQuery(sql);
        }
        //sua
        public void UpDate(string sql)
        {
            //string sql = "update tblSinhVien set TenSV='"+tensv+"' where MaSV='"+masv+"'";
            ac.ExcuteNonQuery(sql);
        }
        //xoa
        public void Delete(string sql)
        {
            //string sql = "delete from tblSinhVien where MaSV='"+masv+"'";
            ac.ExcuteNonQuery(sql);
        }
    }
}
